Database Schema Setup

Before Oracle Insurance Rules Workbench application could be started the database schema for Oracle Insurance Rules Workbench should be created or updated to the latest version. The following steps will create/update DB schema for Oracle Insurance Rules Workbench. From the application server, please execute the following shell command

$ docker run -e dbAdmin=<DB_ADMIN_USER> -e dbAdminPwd=<DB_ADMIN_PWD> -e dbUser=<DB_OIRW_USER> -e dbPwd=<DB_OIRW_PWD> -e 

datasourceURL=<DB_URL> fsgiu-ipacs-saas-docker.dockerhub-iad.oci.oraclecorp.com/oirw-db-installer:1.0.0.31

where:

<DB_ADMIN_USER> - Database user with administrative privileges, but not a SYSDBA

<DB_ADMIN_PWD> - Password for this user<DB_OIRW_USER> - Desired or existing OIRW DB schema name<DB_OIRW_PWD> - Password for OIRW DB schema<DB_URL> - a connection string for Oracle DB server for OIRW schema. (Ex: fsgbu-phx-494.snphxprshared1.gbucdsint02phx.oraclevcn.com:1521:FREE)